package mapper.UserManagement;

import entity.UserInfForEn;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Repository
public interface UserInfForEnMapper {
    /**
     * 完善企业员工信息
     * */
    @Insert("insert into UserInfForEn(userInformationId,name,Sex,phoneNumber,email,enterpriseId,degree,time) values(#{userInformationId},#{name},#{sex},#{phoneNumber},#{email},#{enterpriseId},#{degree},#{time})")
    public int BindUserInfForEnMapper(UserInfForEn userInfForEn);

    @Select("select enterpriseId from UserInfForEn where phoneNumber=#{phoneNumber}")
    public String findEnterpriseId(@Param("phoneNumber") String phoneNumber);

}
